2015-07-13 - 18161.200 - Break Fix - Reload Open order data #SalesDistribution
Break Fix
18161.200 - Reload Open order data
Problem Summary
Reload Open order data
Admin Info
Purpose
|
Need to Reload all open order data and source invoicing status from line instead of header.
|
Requested by
|
Jayne Palferman
|
Issue Date
|
07/13/2015
|
Resolved by
|
Uday Kumar P
|
Resolved Date
|
07/13/2015
|
Document Status
|
Completed
|
Prior Tickets
18161.300
18161.400
Detailed Problem Description
1. Drop Ship Orders need to be deleted by referring to item level billing status whereas earlier they used to be deleted by checking the order header status.
2. Season (0AF_SEAN) & Collection (0AF_COLL) are added to Shipped Orders DSO (ZSD_SHIP) from 2LIS_11_VASCL extractor but the data for these field is not available in PSA.
3. A new source Billing Document Item Data DSO (ZSD_O06) is developed based on datasource 2LIS_13_VDITM and this source has to be populated for all billing documents.
Solution Analysis and Recommendations
1. Drop Ship Orders need to be deleted by referring to item level billing status whereas earlier they used to be deleted by checking the header status. This resulted in developing a new source Order Item Status DSO (ZSD_O04) and lookup logic developed in transformation from Sales Order DSO to Open Order Infocube based on this new DSO.
2. Season (0AF_SEAN) & Collection (0AF_COLL) are added to Shipped Orders DSO (ZSD_SHIP) from 2LIS_11_VASCL extractor. As the data for new fields is not available in PSA, this source has to be reloaded.
3. A new source Billing Document Item Data DSO (ZSD_O06) is developed based on datasource 2LIS_13_VDITM, causing this datasource to be initialized freshly.
Resolution
1) Need to load data for new source Order Item Status (ZSD_O04).
2) Need to deschedule all process chains in BPP system & V3 jobs in NEP System.
3) Need to clear all Extraction Queues by running V3 jobs manually.
4) Need to trigger all delta info packages in BW untill extracted records becomes zero.
5) Need to update all delta records to corresponding data targets.
6) Move corresponding ECC & BW transports to respective production systems.
7) Check whether all corresponding objects for new source are in active state in BPP.
8) Need to find table entries for 11th,12th & 13th application components & split them into parallel jobs depending on available processors in NEP.
9) Delete setup tables for 11th ,12th & 13th Application components.
10) Fill the setup tables for 11th ,12th & 13th Application components.
11) Delete PSA requests for required data sources.
12) Execute Init with out data transfer for required datasources.
13) Execute Full load infopackage for required sources.
14) Need to delete the data from corresponding data targets.
15) Need to update the data to corresponding data targets and perform activation of requests.
16) Need to run Job control and test whether all delta loads are running.
17) Need to reschedule process chains in BPP and V3 jobs in NEP.
18) Checklist for Initialization & detailed steps are attached here for reference:
Initialization Runtime Datasheet 10-07-2015.xlsx
BW & ECC Initialization Runtimes 10-07-2015.pdf
19) Data load issues which were fixed in BW during Initialization Process
Initialization Data Issues 10-07-2015.xlsx
Release Information
2015-07-13 - 18161.200 - Rel Notes - Reload Open Order Data